/****** Object:  Stored Procedure [dbo].spBienBanNhapHangUpdate Script Date: 7/16/2012 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[spBienBanNhapHangUpdate]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
	DROP PROCEDURE [dbo].[spBienBanNhapHangUpdate]
GO

/******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:					Description:
**		--------	--------				-----------------------------------
**		17/07/2012	SongTM					Innit created
*******************************************************************************/

CREATE PROCEDURE [dbo].[spBienBanNhapHangUpdate]
(
	@MaBBNH nvarchar(12),
	@SoHopDong nvarchar(12),
	@NoiNhan nvarchar(50),
	@NgayGioNhan datetime,
	@NgayGioKiem datetime,
	@KetQua nvarchar(200),
	@NguoiDuyet nvarchar(35),
	@KeToan nvarchar(35),
	@ThuKho nvarchar(35)
)

WITH ENCRYPTION

AS

SET NOCOUNT ON

UPDATE [tbl_BienBanNhapHang]
SET [SoHopDong] = @SoHopDong,
	[NoiNhan] = @NoiNhan,
	[NgayGioNhan] = @NgayGioNhan,
	[NgayGioKiem] = @NgayGioKiem,
	[KetQua] = @KetQua,
	[NguoiDuyet] = @NguoiDuyet,
	[KeToan] = @KeToan,
	[ThuKho] = @ThuKho
WHERE	[MaBBNH] = @MaBBNH
GO

--GRANT EXECUTE ON [dbo].[spBienBanNhapHangUpdate] TO [sa]
--GO
